﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReferencedAssemblies="System.dll&#13;&#10;System.Core.dll&#13;&#10;System.Drawing.dll&#13;&#10;System.Windows.Forms.dll&#13;&#10;System.Data.dll&#13;&#10;System.Xml.dll&#13;&#10;Sungero.Domain.Shared&#13;&#10;Sungero.CoreEntities.Shared&#13;&#10;Sungero.Reporting.Shared&#13;&#10;CommonLibrary&#13;&#10;Sungero.Company.Shared&#13;&#10;Sungero.Company.Server&#13;&#10;Sungero.Domain.Interfaces&#13;&#10;Sungero.Docflow.Shared&#13;&#10;Sungero.Docflow.Server" StartReportEvent="_StartReport" ReportInfo.CreatorVersion="2020.2.12.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text.RegularExpressions;
using System.Windows.Forms;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;
using Sungero.Company;
using Sungero.Domain.Shared;
using Sungero.CoreEntities;
using Sungero.Core;
using Resources = Sungero.Docflow.Reports.Resources;


namespace FastReport
{
  public class ReportScript
  { 
    private void _StartReport(object sender, EventArgs e)
    {
      if ((ReportExportFormat)Report.GetParameterValue(&quot;ExportFormat&quot;) == ReportExportFormat.Excel)
      {
        Page1.UnlimitedHeight = true;
      }
    }
  }
}
  </ScriptText>
  <Dictionary>
    <SungeroSqlDataConnection Name="Sungero_Connection" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties" ConnectionStringExpression="[SungeroConnectionString]">
      <TableDataSource Name="Table" Alias="DocumentUsage" DataType="System.Int32" Enabled="true" CanEdit="true" SelectCommand="${DataSource}">
        <Column Name="Employee" DataType="System.String" PropName="Column"/>
        <Column Name="JobTitle" DataType="System.String" PropName="Column"/>
        <Column Name="Department" DataType="System.String" PropName="Column"/>
        <Column Name="Created" DataType="System.Int32" PropName="Column"/>
        <Column Name="Updated" DataType="System.Int32" PropName="Column"/>
        <Column Name="Readed" DataType="System.Int32" PropName="Column"/>
        <CommandParameter Name="PeriodBegin" DataType="6" IsDbType="true" Expression="[PeriodBegin]"/>
        <CommandParameter Name="PeriodEnd" DataType="6" IsDbType="true" Expression="[PeriodEnd]"/>
        <CommandParameter Name="DepartmentId" DataType="11" IsDbType="true" Expression="[DepartmentId]"/>
      </TableDataSource>
    </SungeroSqlDataConnection>
    <SungeroParameter Name="SungeroConnectionString" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties, DontShow" Id="9b8edffa-343c-49e0-8d40-2412f69cbff7" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="PeriodBegin" Id="34a1f6ea-2c4e-4ac7-b452-83d1cced9c44" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="PeriodEnd" Id="a6d314fa-ea3c-4892-b9ae-8441626f02f9" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Department" Id="e201353f-c8bb-4a45-bf45-894958e74399" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IDepartment, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="61b1c19f-26e2-49a5-b3d3-0d3618151e12"/>
    <SungeroParameter Name="DepartmentId" Id="d3ee3aea-ac3d-447c-95f8-2babf9444665" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ClientPeriodEnd" Id="4c0dc683-7872-4f50-b7a3-3e830a35827b" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ReportDate" Id="451f7d8b-9668-4af1-b01c-b565686f99b2" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ClientPeriodBegin" Id="c0859024-ee96-43d3-a323-9225a429c08d" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Empty" Id="6a3cb071-fdd6-4ec6-8897-c642bb668ebe" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
  </Dictionary>
  <ReportPage Name="Page1" FirstPageSource="15" OtherPagesSource="15" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="85.05" CanGrow="true">
      <TextObject Name="Text8" Top="56.7" Width="718.2" Height="28.35" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.PeriodFrom] [ClientPeriodBegin] [Sungero.Docflow.Reports.Resources.DocumentUsageReport.PeriodTo] [ClientPeriodEnd]" HorzAlign="Center" Font="Arial, 12pt, style=Bold">
        <Formats>
          <DateFormat/>
          <DateFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Text9" Width="718.2" Height="18.9" Text="[Empty][ReportDate]" HorzAlign="Right" VertAlign="Center" Font="Arial, 10pt">
        <Formats>
          <GeneralFormat/>
          <DateFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Text18" Top="18.9" Width="718.2" Height="37.8" Text="[Sungero.Docflow.Resources.DocumentUsageReport]" HorzAlign="Center" VertAlign="Center" Font="Arial, 14pt, style=Bold"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="89.05" Width="718.2" Height="56.88" CanGrow="true">
      <TextObject Name="Text1" Width="122.85" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.EmployeeName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
      <TextObject Name="Text2" Left="122.85" Width="122.85" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.JobTitle]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
      <TextObject Name="Text3" Left="245.7" Width="122.85" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.Department]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
      <TextObject Name="Text7" Left="652.05" Width="66.15" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.TotalDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
      <TextObject Name="Text5" Left="463.05" Width="94.5" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.EditedDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
      <TextObject Name="Text4" Left="368.55" Width="94.5" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.CreatedDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
      <TextObject Name="Text6" Left="557.55" Width="94.5" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.ViewedDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="149.93" Width="718.2" Height="37.8" CanGrow="true" CanBreak="true" DataSource="Table">
      <TextObject Name="Text10" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Employee]" Padding="3, 3, 3, 3" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text11" Left="122.85" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.JobTitle]" Padding="3, 3, 3, 3" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text12" Left="245.7" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Department]" Padding="3, 3, 3, 3" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text13" Left="368.55" Width="94.5" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Created]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text14" Left="463.05" Width="94.5" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Updated]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text15" Left="557.55" Width="94.5" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Readed]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text16" Left="652.05" Width="66.15" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[[DocumentUsage.Created]+[DocumentUsage.Updated]+[DocumentUsage.Readed]]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="191.73" Width="718.2" Height="18.9"/>
  </ReportPage>
</Report>
